package com.aierkeji.call.cms.dao.jpa;

import org.springframework.data.jpa.repository.Query;

import com.aierkeji.call.cms.dao.BaseJPADao;
import com.aierkeji.call.cms.dao.jpa.custom.AkjCallReportDaoCustom;
import com.aierkeji.call.cms.entity.AkjCallClueStatistics;

public interface AkjCallReportDao extends BaseJPADao<AkjCallClueStatistics, Long>,AkjCallReportDaoCustom{
	
	@Query("select count(1) from AkjCallClueStatistics where callUserId = :#{#akjCallClueStatistics.callUserId} "
			+ "and groupId=:#{#akjCallClueStatistics.groupId} "
			+ "and year =:#{#akjCallClueStatistics.year} "
			+ "and month=:#{#akjCallClueStatistics.month} "
			+ "and day = :#{#akjCallClueStatistics.day} ")
	  int countBy(AkjCallClueStatistics akjCallClueStatistics) ;
	
}
